Skip Headers

Oracle® Database Backup and Recovery Advanced User's Guide 10g Release 2 (10.2) Part Number B14191-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# Verifying User-Managed Backups

You should periodically verify your backups to ensure that they are usable for recovery. This section contains the following topics:

- Testing the Restore of Backups

- Running the DBVERIFY Utility

## Testing the Restore of Backups

The best way to test the usability of backups is to restore them to a separate host and attempt to open the database, performing media recovery if necessary. This option requires that you have a separate host available for the restore procedure.

See Also: "Restoring Datafiles with Operating System Utilities" "Restoring Archived Redo Logs with Operating System Utilities" "Restoring Control Files" "Performing Complete User-Managed Media Recovery" to learn how to recover files with SQL*Plus

## Running the DBVERIFY Utility

The DBVERIFY program is an external command-line utility that performs a physical data structure integrity check on an offline datafile. Use DBVERIFY primarily when you need to ensure that a user-managed backup of a datafile is valid before it is restored or as a diagnostic aid when you have encountered data corruption problems.

The name and location of DBVERIFY is dependent on your operating system. For example, to perform an integrity check on datafile `tbs_52.f` on UNIX, you can run the `dbv` command as follows:

    % dbv file=tbs_52.f

Sample `dbv` output follows:

    DBVERIFY - Verification starting : FILE = users01.dbf

    DBVERIFY - Verification complete

    Total Pages Examined         : 250
    Total Pages Processed (Data) : 1
    Total Pages Failing   (Data) : 0
    Total Pages Processed (Index): 0
    Total Pages Failing   (Index): 0
    Total Pages Processed (Other): 2
    Total Pages Processed (Seg)  : 0
    Total Pages Failing   (Seg)  : 0
    Total Pages Empty            : 247
    Total Pages Marked Corrupt   : 0
    Total Pages Influx           : 0

See Also: Oracle Database Utilities to learn about DBVERIFY